Instructional Delivery Method: Group Live-Seminar

CPE Credit and NASBA Field of Study: 8 Hours, Finance

This intensive one-day, hands-on workshop examines several case studies of budgeting, projections and financial modeling using Excel’s most sophisticated applications designed especially for this task.

  • Understand Basic Budgeting, Projections and Modeling Concepts for Financial Projections

     

  • Understand Professional Modeling Concepts Including Input Cells for Key Revenue or Expense Drivers and Template Construction for Effective Models

     

  • Understand the Linear Regression Equation, Use it for a Variety of Modeling Tasks and use Excel Tools to Automatically Generate the Linear Regression Equation

     

  • Learn the AICPA/SAARS Definitions and Requirements: Forecast v. Projection

     

  • Learn To Model The Sales Forecast, Fixed and Variable Costs and the Income Statement

     

  • Learn Three Different Methodologies To Model the Balance Sheet: (1) Percent of Sales, (2) Linear Regression Using the Sales Forecast and (3) Financial Analysis Using Various Excel Tools for Desired Objectives

     

  • Understand the Weighted Average Cost of Capital (WACC) and the Capital Asset Pricing Model (CAPM)

     

  • Model the Firm’s Capital Structure

     

  • Understand the Sustainable Growth Model

     

  • Understand Sensitivity Analysis Using Excel Data Tables

     

  • Learn How To Program Excel Solver for Optimal Decision Making: Model the Optimal Capital Structure and Model the Optimal Sustainable Growth Rate

     

 
  • Budgeting and Financial Modeling Concepts – Constructing Effective Modeling Templates

     

  • Linear Regression Analysis Using Excel

     

  • Modeling the Sales Forecast

     

  • Modeling the Income Statement Including Fixed and Variable Costs and Flexible Budgeting

     

  • “What If” Sensitivity Analysis Using Excel Data Tables

     

  • Forecasting Operating Income with Monte Carlo Simulations

     

  • Incorporating Excel Spinners and Sliders for Key Revenue and Expense Drivers

     

  • Connecting Financial Models to Excel Graphics for Dynamic Presentations

     

  • Modeling the Balance Sheet

     

  • Modeling the Weighted Average Cost of Capital (WACC) and the Capital Asset Pricing Model (CAPM) – Modeling and the Firm’s Capital Structure

     

  • Modeling Optimal Sustainable Growth

     

  • Programming Excel Solver for Optimal Solutions

     

  • Modeling Optimal Capital Structure

     

Who should attend: This course is designed for CPAs and financial professionals who want a state-of-the-art update and a crystal-clear explanation of advanced budgeting and financial modeling tools and techniques using Excel 2010. This seminar is perfect for CFOs, CPAs, treasurers, controllers, financial and security analysts, budget directors/analysts, staff accountants and auditors.

Prerequisites: Basic Knowledge of Excel
and Finance

Program Level:
Intermediate

Advance preparation:
None

For a comprehensive course description and to view a brochure click a link below:

To register for this In-House Seminar, please fill out this questionnaire to help pinpoint your group's in-house needs, and assist NCCE in putting together a top-notch in-house seminar for your organization.

 

Cost effective for 10 or more employees. Click here for more information on in-house seminars.

NCCE is only holding in-house seminars right now but NCCE will offer our seminars including Budgeting, Projections and Financial Modeling Using Excel 2010 to the public starting in 2013.

 

Click here to be put on a notification list for NCCE's public seminars starting in 2013.
The National Center for Continuing Education is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.
For more information regarding administrative policies such as complaint and refund,
please contact our offices at 850-561-6081.

National Center for Continuing Education

967 Briarcliff Drive - Tallahassee, FL - 32308 - Fax: (850) 222-4862

Phone: (850) 561-6081 - contact@nccetraining.com